https://store-images.s-microsoft.com/image/apps.2676.72807def-158f-4624-b081-77ea3119057a.5e976c2e-ca48-4cfa-acd7-2204de13b0c1.b44b489d-d149-4c08-b232-ac01ed5e19f5

Data Imports and Migration

by ERP Connect Consulting LLC

Free trial badge

Load and Migrate Data in 90% Less Time Than with Configuration Packages

  • Data Imports

  • Historical GL data loads during implementation cycles - avoid lengthy Config Pack Uploads
        • Typically takes 90% less time than a configuration package.
  • Utilize for loading large monthly journal entries.
  • Reduce loading and wait times on configuration packages and edit in Excel.
  • Ability to load Accounts Payable transactions into General Journals
  • Ability to load Accounts Receivable transactions into General Journals
  • Ability to use translation table in Business Central to avoid chart of accounts mapping in file
        • Map old Chart of Accounts to New Chart of Accounts + Dimensions in Business Central
        • Removes the complexities of having to Map this in the import file

Data Migrations / Table Migrations
  • Utilize when setting up new companies (easily copy data from one company to another)
    • Bi-Directional Pushing Data Between different BC Companies - Like Test to Production, or vice versa
    • Direct Data Transfer takes minutes, instead of hours
    • Ability to pre filter the data from the source table, before processing:
      • Only migrate Canadian Customers
      • Only move Customer with a Posting Group of DOMESTIC
      • Only move revenue accounts when migrating the Chart of Accounts
      • Only move Items that have been updated in the last 12 months
  • Allows you to do mass imports from company to company for dozens of standard tables in Business Central
      • Sales (Customer, Setups, Items, etc.)
      • Purchasing (Vendors, Setups, Items, etc.)
      • General Ledger (COA, Dimensions, Setups, etc.)
      • Fixed Assets (FA Card, Setups,)
      • Financial Reports

At a glance

https://store-images.s-microsoft.com/image/apps.9414.72807def-158f-4624-b081-77ea3119057a.320b57ab-fd34-4148-80f4-878f4a12c3aa.e528beb4-43d0-4d6a-a639-3eb54af99879
/staticstorage/linux/20250201.1/assets/videoOverlay_7299e00c2e43a32cf9fa.png
https://store-images.s-microsoft.com/image/apps.45659.72807def-158f-4624-b081-77ea3119057a.320b57ab-fd34-4148-80f4-878f4a12c3aa.f6c08faf-cfe0-42ff-a8af-7961ddb359f5
/staticstorage/linux/20250201.1/assets/videoOverlay_7299e00c2e43a32cf9fa.png
https://store-images.s-microsoft.com/image/apps.34070.72807def-158f-4624-b081-77ea3119057a.5e976c2e-ca48-4cfa-acd7-2204de13b0c1.25d2b5c5-f939-4291-8c7d-d5d2c5b2f230
/staticstorage/linux/20250201.1/assets/videoOverlay_7299e00c2e43a32cf9fa.png
https://store-images.s-microsoft.com/image/apps.50049.72807def-158f-4624-b081-77ea3119057a.e72b3a7b-8d06-4332-ab35-ff511cb3974a.6d5a5852-3de8-4aa8-ba8d-4ebd91cf0815
https://store-images.s-microsoft.com/image/apps.31911.72807def-158f-4624-b081-77ea3119057a.e72b3a7b-8d06-4332-ab35-ff511cb3974a.06084c5a-8753-440a-b295-2405984697cf
https://store-images.s-microsoft.com/image/apps.47594.72807def-158f-4624-b081-77ea3119057a.e72b3a7b-8d06-4332-ab35-ff511cb3974a.0965264f-5735-4666-86fb-16ff2ac2ae75
https://store-images.s-microsoft.com/image/apps.51626.72807def-158f-4624-b081-77ea3119057a.e72b3a7b-8d06-4332-ab35-ff511cb3974a.9762fe87-83ed-421c-a3f4-f52e6314664c
https://store-images.s-microsoft.com/image/apps.61776.72807def-158f-4624-b081-77ea3119057a.e72b3a7b-8d06-4332-ab35-ff511cb3974a.6bab002c-5180-46c7-af85-88bb6eee97f8